<Page id="1" templateExtension="html" relativePath="..\.." fullRelativePath=".\gharardad\programmer_part" secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" wizardTheme="Cobalt" wizardThemeType="File" needGeneration="0">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="1" connection="projectkar" dataSource="SELECT CONTRACT.*,&quot;USER&quot;.NAME AS OWNER,PROJECT.NAME AS PROJECT_NAME,SITUATIONS_DEF_SC.&quot;DESC&quot; SITUATION_DESC
FROM CONTRACT,
PROJECT,
&quot;USER&quot;,
CONTRACT_SITUATION,
SITUATIONS_DEF_SC
WHERE ( 
     (CONTRACT.PRO_ID = PROJECT.ID) 
 AND (PROJECT.USE_ID = &quot;USER&quot;.ID)
 AND (CONTRACT_SITUATION.CONTRACT_ID = CONTRACT.ID) 
 AND CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
 AND (SITUATIONS_DEF_SC.CODE = CONTRACT_SITUATION.SITUATION)               
 AND (CONTRACT.ID={CONTRACT_ID})                           
 AND contract.use_id={PROGRAMMER_ID}
);" name="CONTRACT_USER_PROJECT" pageSizeLimit="100" wizardCaption="List of CONTRACT, &quot; USER&quot;, PROJECT " wizardTheme="Cobalt" wizardThemeType="File" wizardGridType="Justified" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="26" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="CONTRACT_NAME" fieldSource="CONTRACT_NAME" wizardCaption="CONTRACT NAME" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="50" wizardMaxLength="80" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="27" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="PROJECT_NAME" fieldSource="PROJECT_NAME" wizardCaption="PROJECT NAME" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="28" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="OWNER" fieldSource="OWNER" wizardCaption="OWNER" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="29" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="DATE_OF_CREATION" fieldSource="DATE_OF_CREATION" wizardCaption="DATE OF CREATION" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="30" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="EXPIRATION" fieldSource="EXPIRATION" wizardCaption="EXPIRATION" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="31" fieldSourceType="DBColumn" dataType="Float" html="False" editable="False" name="CONTRACT_MONEY" fieldSource="CONTRACT_MONEY" wizardCaption="CONTRACT MONEY" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="32" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="LAST_SITUATION" fieldSource="LAST_SITUATION" wizardCaption="LAST SITUATION" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="50" wizardMaxLength="100" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="14" tableName="CONTRACT" posWidth="172" posHeight="214" posLeft="10" posTop="10"/>
				<JoinTable id="19" tableName="&quot;USER&quot;" posWidth="155" posHeight="222" posLeft="385" posTop="34"/>
				<JoinTable id="22" tableName="PROJECT" posWidth="100" posHeight="188" posLeft="237" posTop="112"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="24" fieldLeft="CONTRACT.PRO_ID" fieldRight="PROJECT.ID" tableLeft="CONTRACT" tableRight="PROJECT" conditionType="Equal" joinType="inner"/>
				<JoinTable2 id="25" fieldLeft="PROJECT.USE_ID" fieldRight="&quot;USER&quot;.ID" tableLeft="PROJECT" tableRight="&quot;USER&quot;" conditionType="Equal" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="15" tableName="CONTRACT" alias="CONTRACT_NAME" fieldName="CONTRACT.NAME"/>
				<Field id="16" tableName="CONTRACT" fieldName="DATE_OF_CREATION"/>
				<Field id="17" tableName="CONTRACT" alias="CONTRACT_MONEY" fieldName="CONTRACT.MONEY"/>
				<Field id="18" tableName="CONTRACT" fieldName="EXPIRATION"/>
				<Field id="20" tableName="&quot;USER&quot;" alias="OWNER" fieldName="&quot;USER&quot;.NAME"/>
				<Field id="21" tableName="&quot;USER&quot;" alias="LAST_SITUATION" fieldName="&quot;USER&quot;.DESCRIPTION"/>
				<Field id="23" tableName="PROJECT" alias="PROJECT_NAME" fieldName="PROJECT.NAME"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="33" variable="PROGRAMMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
				<SQLParameter id="34" variable="CONTRACT_ID" parameterType="URL" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="CONTRACT_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
		<Grid id="35" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="1" name="if_contract_on_built" connection="projectkar" dataSource="SELECT CONTRACT.*
FROM CONTRACT,
CONTRACT_SITUATION,
SITUATIONS_DEF_SC
WHERE ( 
 (CONTRACT_SITUATION.CONTRACT_ID = CONTRACT.ID) 
 AND CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
 AND (SITUATIONS_DEF_SC.CODE = CONTRACT_SITUATION.SITUATION)               
 AND contract.use_id={PROGRAMMER_ID}
 AND (CONTRACT.ID={CONTRACT_ID})                           
 AND SITUATIONS_DEF_SC.TEXT='BUILT'
);" pageSizeLimit="100" wizardCaption="List of CONTRACT " wizardTheme="Cobalt" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Link id="36" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="refuse_doing" wizardTheme="Cobalt" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="40" sourceType="DataField" name="CONTRACT_ID" source="ID"/>
					</LinkParameters>
				</Link>
				<Link id="37" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="report_termination" wizardTheme="Cobalt" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="41" sourceType="DataField" name="CONTRACT_ID" source="ID"/>
					</LinkParameters>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables/>
			<JoinLinks/>
			<Fields/>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="38" variable="PROGRAMMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
				<SQLParameter id="39" variable="CONTRACT_ID" parameterType="URL" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="CONTRACT_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="see_contract_status.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="see_contract_status.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="see_contract_status.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="see_contract_statusHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
